select a.dftpic as dftpic1, b.Latitude as b_Latitude, b.Longitude as b_Longitude,* from [houses] a, [base_property] b, [base_cityDistrict] c where audit=1 and a.pid = b.pid and b.did = c.id and a.del=0 and a.locker=0 and b.del=0 and b.locker=0 and a.isShowEn=0 and a.houseType = 3 and (b.cnpropertyname like '%Ambassy Court%' or b.enpropertyname like '%Ambassy Court%') order by updateTime Desc, a.dftpic desc
Open kitchen. Extremely big living and dinning. Floor heating, throughout wall insulation, daikin central ac, double glazing windows. Smeg oven, Coway filtered ...
The apartment is particularly good, Luxury decoration with spacious living room and bedrooms,
especially good north-south light permeability. nice river view.
...